Configure Application Server Settings

You may need to edit the OneStream Application Server Configuration so users can create and change data in the additional database tables used by Planning solutions. If other OneStream Solutions are in the application, these adjustments may already exist. See Solution Database Migration Advice

Before you begin, make sure these security group settings include the users who work on and set up Planning solutions.

NOTE: Group settings are applicable to all OneStream Solutions, so keep the group names generic.

  1. Start the OneStream Server Configuration Utility as an Administrator.

  2. Select Open Application Server Configuration File > Database.

  3. Edit the following OneStream Database Server properties:

  • Access Group for Ancillary Tables: Select a group that includes those who will access records.

  • Can Create Ancillary Tables: True

  • Can Edit Ancillary Table Data: True

  • Maintenance Group for Ancillary Tables: Select a group who will edit and maintain tables.

  • Table Creation Group for Ancillary Tables: Select a group who can create tables.

  1. Restart Internet Information Server.